MySpreadsheet

R1C1 reference style

•On the View tab, select the R1C1 reference style checkbox.

•When working in macOS, select the View > R1C1 command from the command menu.

In the R1C1 style, both columns and rows are denoted by numbers. The address of a cell is determined using the formula RnCm, where:

•R stands for Row, and n stands for row number.

•C stands for Column, and m stands for column number.

For example, the name of D5 cell in the R1C1 style is R5C4.

Absolute reference	R3C2 (an absolute reference to a cell at the intersection of row 3 and column 2) R3 (an absolute reference to row 3) C2 (an absolute reference to column 2)
Relative reference	RC (a relative reference to the current cell) R[-2] (a relative reference to the row located 2 rows above the current row) C[3] (a relative reference to the column located 3 columns to the right of the current column)
Mixed reference	RC5 (a reference to a cell in the current row in column 5) RC[-5] (a reference to a cell located in the current row 5 columns to the left of the current cell) R3C[2] (a reference to a cell located in row 3, 2 columns to the right of the current cell) R[3]C[-2] (a reference to a cell located 3 rows below and 2 columns to the left of the current cell) R[-3]C[2] (a reference to a cell located 3 rows above and 2 columns to the right of the current cell)

Absolute reference

R3C2 (an absolute reference to a cell at the intersection of row 3 and column 2)

R3 (an absolute reference to row 3)

C2 (an absolute reference to column 2)

Relative reference

RC (a relative reference to the current cell)

R[-2] (a relative reference to the row located 2 rows above the current row)

C[3] (a relative reference to the column located 3 columns to the right of the current column)

Mixed reference

RC5 (a reference to a cell in the current row in column 5)

RC[-5] (a reference to a cell located in the current row 5 columns to the left of the current cell)

R3C[2] (a reference to a cell located in row 3, 2 columns to the right of the current cell)

R[3]C[-2] (a reference to a cell located 3 rows below and 2 columns to the left of the current cell)

R[-3]C[2] (a reference to a cell located 3 rows above and 2 columns to the right of the current cell)

If a spreadsheet contains absolute references when switching from A1 to R1C1 reference style, they will remain absolute afterwards.